Row Limit

Set a row limit for the current query. This limits the number of rows that can be returned by the query.

Note: In addition to the row limit, there is also a master query limit set by the administrator in the Admin Console. Pyramid uses the lower of the two limits by default. For more information about the master limits, see Query limits.

Specify the row limit

In Discover Pro:

  1. From the Query ribbon, click Query Settings > Row Limit.
  2. In the Row Limit dialog, either:
    • Select System Default to set the row limit to the default set in the Admin console.
    • Use the Number of Shown Rows field to enter your required row limit.
  3. Tip: You can click Reset (purple arrow) to revert back to the default row limit.

  4. Optionally, select the Apply this limit to queries against the data source checkbox to enforce the row limit set in the previous step for both the Result Limit and the SQL Result Limit.
  5. Note: Selecting this option means that the master query limit for the Result Limit and the SQL Result Limit is always overridden with this value for this discovery. For more information about master limits, see Query limits.

  6. Click Apply to save your changes.

The number of rows that can be returned by the query is set to the Row Limit as configured.